<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>AmpleHarvest: cTABLE_Harvest_Requests.php Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">AmpleHarvest
   &#160;<span id="projectnumber">0.0.1</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="pages.html"><span>Related&#160;Pages</span></a></li>
      <li><a href="modules.html"><span>Modules</span></a></li>
      <li><a href="namespaces.html"><span>Namespaces</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>File&#160;Members</span></a></li>
    </ul>
  </div>
</div>
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
  initNavTree('c_t_a_b_l_e___harvest___requests_8php.html','');
</script>
<div id="doc-content">
<div class="header">
  <div class="headertitle">
<div class="title">cTABLE_Harvest_Requests.php</div>  </div>
</div>
<div class="contents">
<a href="c_t_a_b_l_e___harvest___requests_8php.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00005"></a>00005         use\ampleharvest\code;
<a name="l00006"></a>00006         require_once dirname(dirname(dirname(__FILE__))) . <span class="stringliteral">&#39;/config/cConfig.php&#39;</span>;
<a name="l00007"></a>00007         require_once <span class="stringliteral">&#39;cTABLE_Drop_Down_Options.php&#39;</span>;
<a name="l00011"></a>00011         require_once code\cConfig::C_STR_DATABASE_LIB_PATH . <span class="stringliteral">&quot;/Classes/cTable.php&quot;</span>;
<a name="l00015"></a>00015         require_once code\cConfig::C_STR_DATABASE_LIB_PATH . <span class="stringliteral">&quot;/Classes/ColTypes.php&quot;</span>;
<a name="l00033"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html">00033</a>         <span class="keyword">class </span><a class="code" href="classc_t_a_b_l_e___harvest___requests.html" title="Includes the base class for Tables (uses base path from the cinfo file.">cTABLE_Harvest_Requests</a> <span class="keyword">extends</span> cTable
<a name="l00034"></a>00034         {
<a name="l00035"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aa7fe491587f118f1d2d5f3bb8668356a">00035</a>                 <span class="keyword">const</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aa7fe491587f118f1d2d5f3bb8668356a">C_INT_MAX_RESULTS_RETURNED</a> = 500;
<a name="l00036"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ab13a06e00c9892ff6412025b610d194b">00036</a>                 <span class="keyword">const</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ab13a06e00c9892ff6412025b610d194b">C_INT_DEFAULT_RESULTS_RETURNED</a> = 100;
<a name="l00041"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ad077898da1668be20c85ec881a673c2e">00041</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ad077898da1668be20c85ec881a673c2e">$m_int_COL_ID</a> = null;
<a name="l00042"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a2b1e9799c8f7c441723288dc607686f8">00042</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a2b1e9799c8f7c441723288dc607686f8">$m_int_COL_RequestNum</a> = null;
<a name="l00043"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a9ae7b097d8f2b5971a0d5a6ceb265e72">00043</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a9ae7b097d8f2b5971a0d5a6ceb265e72">$m_int_COL_UserID</a> = null;
<a name="l00044"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a5aea4428a23caad2ac9b49d57603872f">00044</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a5aea4428a23caad2ac9b49d57603872f">$m_int_COL_URL</a> = null;
<a name="l00045"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#abfecd09ecf44d206ef19fd5d87775ef6">00045</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#abfecd09ecf44d206ef19fd5d87775ef6">$m_int_COL_KeyWords</a> = NULL;
<a name="l00046"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a13f5616a6fcfa6b11723a2a91cf3464e">00046</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a13f5616a6fcfa6b11723a2a91cf3464e">$m_int_COL_WholeSite</a> = NULL;
<a name="l00047"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a11ea7f32f14a7ff59c65bcecc6e8346e">00047</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a11ea7f32f14a7ff59c65bcecc6e8346e">$m_int_COL_DateRequested</a> = null;
<a name="l00048"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a026684b4ce2c624123edd6e1912e7be4">00048</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a026684b4ce2c624123edd6e1912e7be4">$m_int_COL_DateUpdated</a> = null;
<a name="l00049"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a23281ba5f596fe2a4ab8aa2710431706">00049</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a23281ba5f596fe2a4ab8aa2710431706">$m_int_COL_Status</a> = null;
<a name="l00050"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a207ebd7f7bbfed4e9e014a3039339a0d">00050</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a207ebd7f7bbfed4e9e014a3039339a0d">$m_int_COL_Description</a> = null;
<a name="l00051"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a6c4c235bdc22d08513df177c041a3d57">00051</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a6c4c235bdc22d08513df177c041a3d57">$m_int_COL_Frequency</a> = null;
<a name="l00052"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a8d4b79c32834ea36c3c67b3cf9b8a22f">00052</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a8d4b79c32834ea36c3c67b3cf9b8a22f">$m_int_COL_Sensitivity</a> = null;
<a name="l00053"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a28dcff5c7402a2999eb81e6fb3d27d78">00053</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a28dcff5c7402a2999eb81e6fb3d27d78">$m_int_COL_Risk</a> = null;
<a name="l00054"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a360d8be4166847053f9a036d14a2b903">00054</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a360d8be4166847053f9a036d14a2b903">$m_int_COL_Type</a> = null;
<a name="l00055"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a55c0fe694ba1231f7cc0b7829c768233">00055</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a55c0fe694ba1231f7cc0b7829c768233">$m_int_COL_Reason</a> = null;
<a name="l00056"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ac7dcd5393bbfd64bec6160ec0fdcf45b">00056</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ac7dcd5393bbfd64bec6160ec0fdcf45b">$m_int_COL_Comment</a> = null;
<a name="l00057"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a79edb3e5619e3df15e30c669a784839d">00057</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a79edb3e5619e3df15e30c669a784839d">$m_int_COL_Discussion</a> = null;
<a name="l00058"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a4d6c5b2d04ffa060a5f01950bc046ceb">00058</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a4d6c5b2d04ffa060a5f01950bc046ceb">$m_int_COL_Language</a> = null;
<a name="l00059"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aaa9d3c221074243547aace5f10de63f1">00059</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aaa9d3c221074243547aace5f10de63f1">$m_int_COL_Classification</a> = null;
<a name="l00060"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ab831144db227f14353401634b2652d27">00060</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#ab831144db227f14353401634b2652d27">$m_int_COL_SCI</a> = null;
<a name="l00061"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a0e6794fef233e297ac960b8deca74fde">00061</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a0e6794fef233e297ac960b8deca74fde">$m_int_COL_Distro</a> = null;
<a name="l00069"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a095c5d389db211932136b53f25f39685">00069</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a095c5d389db211932136b53f25f39685" title="This constructor sets all the required column data.">__construct</a>()
<a name="l00070"></a>00070                 {
<a name="l00071"></a>00071                         $this-&gt;m_str_TableName = <span class="stringliteral">&quot;Harvest_Requests&quot;</span>;
<a name="l00072"></a>00072                         $this-&gt;set_Engine(self::C_STR_ENGINE_INNODB);
<a name="l00073"></a>00073 
<a name="l00074"></a>00074                         <span class="comment">//Create Column Objects</span>
<a name="l00075"></a>00075                         $obj_COL_ID = <span class="keyword">new</span> cColVarChar(<span class="stringliteral">&quot;id&quot;</span>);
<a name="l00076"></a>00076                         $obj_COL_ID-&gt;set_Length(36);
<a name="l00077"></a>00077                         $obj_COL_ID-&gt;set_Index(abs_Column::c_int_INDEX_PRIMARY);
<a name="l00078"></a>00078                         $obj_COL_ID-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the ID of harvest requests.&quot;</span>);
<a name="l00079"></a>00079                         $obj_COL_ID-&gt;set_Editable(<span class="keyword">false</span>);
<a name="l00080"></a>00080                         $obj_COL_ID-&gt;set_Label(<span class="stringliteral">&quot;ID&quot;</span>);
<a name="l00081"></a>00081 
<a name="l00082"></a>00082                         $obj_COL_UserID = <span class="keyword">new</span> cColVarChar(<span class="stringliteral">&quot;user_id&quot;</span>);
<a name="l00083"></a>00083                         $obj_COL_UserID-&gt;set_Length(36);
<a name="l00084"></a>00084                         $obj_COL_UserID-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the user GUID.&quot;</span>);
<a name="l00085"></a>00085                         $obj_COL_UserID-&gt;set_Label(<span class="stringliteral">&quot;User GUID&quot;</span>);
<a name="l00086"></a>00086 
<a name="l00087"></a>00087                         $obj_COL_URL = <span class="keyword">new</span> cColText(<span class="stringliteral">&quot;url&quot;</span>);
<a name="l00088"></a>00088                         $obj_COL_URL-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the Target URL.&quot;</span>);
<a name="l00089"></a>00089                         $obj_COL_URL-&gt;set_Label(<span class="stringliteral">&quot;Source URL&quot;</span>);
<a name="l00090"></a>00090 
<a name="l00091"></a>00091                         $obj_COL_KeyWords = <span class="keyword">new</span> cColText(<span class="stringliteral">&quot;key_words&quot;</span>);
<a name="l00092"></a>00092                         $obj_COL_KeyWords-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the key words for the request.&quot;</span>);
<a name="l00093"></a>00093                         $obj_COL_KeyWords-&gt;set_Label(<span class="stringliteral">&quot;Keywords&quot;</span>);
<a name="l00094"></a>00094 
<a name="l00095"></a>00095                         $obj_COL_WholeSite = <span class="keyword">new</span> cColTinyInt(<span class="stringliteral">&quot;whole_site&quot;</span>);
<a name="l00096"></a>00096                         $obj_COL_WholeSite-&gt;set_Comment(<span class="stringliteral">&quot;This column determines if the user wants everything or not.&quot;</span>);
<a name="l00097"></a>00097                         $obj_COL_WholeSite-&gt;set_Label(<span class="stringliteral">&quot;Whole Site&quot;</span>);
<a name="l00098"></a>00098 
<a name="l00099"></a>00099                         $obj_COL_DateRequested = <span class="keyword">new</span> cColDateTime(<span class="stringliteral">&quot;date_requested&quot;</span>);
<a name="l00100"></a>00100                         $obj_COL_DateRequested-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the last run time.&quot;</span>);
<a name="l00101"></a>00101                         $obj_COL_DateRequested-&gt;set_Label(<span class="stringliteral">&quot;Date Requested&quot;</span>);
<a name="l00102"></a>00102 
<a name="l00103"></a>00103                         $obj_COL_DateUpdated = <span class="keyword">new</span> cColDateTime(<span class="stringliteral">&quot;date_updated&quot;</span>);
<a name="l00104"></a>00104                         $obj_COL_DateUpdated-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the next run time.&quot;</span>);
<a name="l00105"></a>00105                         $obj_COL_DateUpdated-&gt;set_Label(<span class="stringliteral">&quot;Date Updated&quot;</span>);
<a name="l00106"></a>00106 
<a name="l00107"></a>00107                         $obj_COL_Status = <span class="keyword">new</span> cColTinyInt(<span class="stringliteral">&quot;status&quot;</span>);
<a name="l00108"></a>00108                         $obj_COL_Status-&gt;set_Comment(<span class="stringliteral">&quot;This column holds current request status.&quot;</span>);
<a name="l00109"></a>00109                         $obj_COL_Status-&gt;set_Label(<span class="stringliteral">&quot;Status&quot;</span>);
<a name="l00110"></a>00110 
<a name="l00111"></a>00111                         $obj_COL_Description = <span class="keyword">new</span> cColLongBlob(<span class="stringliteral">&quot;description&quot;</span>);
<a name="l00112"></a>00112                         $obj_COL_Description-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the request description.&quot;</span>);
<a name="l00113"></a>00113                         $obj_COL_Description-&gt;set_Label(<span class="stringliteral">&quot;Description&quot;</span>);
<a name="l00114"></a>00114 
<a name="l00115"></a>00115                         $obj_COL_Frequency = <span class="keyword">new</span> cColSmallInt(<span class="stringliteral">&quot;frequency&quot;</span>);
<a name="l00116"></a>00116                         $obj_COL_Frequency-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the harvest frequency.&quot;</span>);
<a name="l00117"></a>00117                         $obj_COL_Frequency-&gt;set_Label(<span class="stringliteral">&quot;Frequency&quot;</span>);
<a name="l00118"></a>00118 
<a name="l00119"></a>00119                         $obj_COL_Sensitivity = <span class="keyword">new</span> cColSmallInt(<span class="stringliteral">&quot;sensitivity&quot;</span>);
<a name="l00120"></a>00120                         $obj_COL_Sensitivity-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the sensitivity level.&quot;</span>);
<a name="l00121"></a>00121                         $obj_COL_Sensitivity-&gt;set_Label(<span class="stringliteral">&quot;Sensitive&quot;</span>);
<a name="l00122"></a>00122 
<a name="l00123"></a>00123                         $obj_COL_Risk = <span class="keyword">new</span> cColText(<span class="stringliteral">&quot;risk&quot;</span>);
<a name="l00124"></a>00124                         $obj_COL_Risk-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the risk level.&quot;</span>);
<a name="l00125"></a>00125                         $obj_COL_Risk-&gt;set_Label(<span class="stringliteral">&quot;Risk&quot;</span>);
<a name="l00126"></a>00126 
<a name="l00127"></a>00127                         $obj_COL_Type = <span class="keyword">new</span> cColSmallInt(<span class="stringliteral">&quot;type&quot;</span>);
<a name="l00128"></a>00128                         $obj_COL_Type-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the target type description.&quot;</span>);
<a name="l00129"></a>00129                         $obj_COL_Type-&gt;set_Label(<span class="stringliteral">&quot;Source Type&quot;</span>);
<a name="l00130"></a>00130 
<a name="l00131"></a>00131                         $obj_COL_Reason = <span class="keyword">new</span> cColLongBlob(<span class="stringliteral">&quot;reason&quot;</span>);
<a name="l00132"></a>00132                         $obj_COL_Reason-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the harvest request reason.&quot;</span>);
<a name="l00133"></a>00133                         $obj_COL_Reason-&gt;set_Label(<span class="stringliteral">&quot;Justification&quot;</span>);
<a name="l00134"></a>00134 
<a name="l00135"></a>00135                         $obj_COL_Comment = <span class="keyword">new</span> cColLongBlob(<span class="stringliteral">&quot;comment&quot;</span>);
<a name="l00136"></a>00136                         $obj_COL_Comment-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the harvest request comment section.&quot;</span>);
<a name="l00137"></a>00137                         $obj_COL_Comment-&gt;set_Label(<span class="stringliteral">&quot;Comment&quot;</span>);
<a name="l00138"></a>00138 
<a name="l00139"></a>00139                         $obj_COL_Discussion = <span class="keyword">new</span> cColLongBlob(<span class="stringliteral">&quot;discussion&quot;</span>);
<a name="l00140"></a>00140                         $obj_COL_Discussion-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the harvest request discussions.&quot;</span>);
<a name="l00141"></a>00141                         $obj_COL_Discussion-&gt;set_Label(<span class="stringliteral">&quot;Discussion&quot;</span>);
<a name="l00142"></a>00142 
<a name="l00143"></a>00143                         $obj_COL_Language = <span class="keyword">new</span> cColText(<span class="stringliteral">&quot;language&quot;</span>);
<a name="l00144"></a>00144                         $obj_COL_Language-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the URL target language.&quot;</span>);
<a name="l00145"></a>00145                         $obj_COL_Language-&gt;set_Label(<span class="stringliteral">&quot;Language&quot;</span>);
<a name="l00146"></a>00146 
<a name="l00147"></a>00147                         $obj_COL_Classification = <span class="keyword">new</span> cColVarChar(<span class="stringliteral">&quot;classification&quot;</span>);
<a name="l00148"></a>00148                         $obj_COL_Classification-&gt;set_Length(36);
<a name="l00149"></a>00149                         $obj_COL_Classification-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the classification of the Request.&quot;</span>);
<a name="l00150"></a>00150                         $obj_COL_Classification-&gt;set_Label(<span class="stringliteral">&quot;Classification&quot;</span>);
<a name="l00151"></a>00151 
<a name="l00152"></a>00152                         $obj_COL_SCI = <span class="keyword">new</span> cColVarChar(<span class="stringliteral">&quot;sci&quot;</span>);
<a name="l00153"></a>00153                         $obj_COL_SCI-&gt;set_Length(100);
<a name="l00154"></a>00154                         $obj_COL_SCI-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the SCI portion of the classification of the Request.&quot;</span>);
<a name="l00155"></a>00155                         $obj_COL_SCI-&gt;set_Label(<span class="stringliteral">&quot;SCI&quot;</span>);
<a name="l00156"></a>00156 
<a name="l00157"></a>00157                         $obj_COL_Distro = <span class="keyword">new</span> cColVarChar(<span class="stringliteral">&quot;distro&quot;</span>);
<a name="l00158"></a>00158                         $obj_COL_Distro-&gt;set_Length(100);
<a name="l00159"></a>00159                         $obj_COL_Distro-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the Distro portion of the classification of the Request.&quot;</span>);
<a name="l00160"></a>00160                         $obj_COL_Distro-&gt;set_Label(<span class="stringliteral">&quot;Distro&quot;</span>);
<a name="l00161"></a>00161 
<a name="l00162"></a>00162                         $obj_COL_RequestNum = <span class="keyword">new</span> cColInt(<span class="stringliteral">&quot;requestNum&quot;</span>);
<a name="l00163"></a>00163                         $obj_COL_RequestNum-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the Request Number.&quot;</span>);
<a name="l00164"></a>00164                         $obj_COL_RequestNum-&gt;set_Label(<span class="stringliteral">&quot;Request #&quot;</span>);
<a name="l00165"></a>00165 
<a name="l00166"></a>00166                         <span class="comment">//Set up connection</span>
<a name="l00167"></a>00167                         $this-&gt;m_obj_Connection = <span class="keyword">new</span> cConnection(<span class="stringliteral">&quot;AmpleHarvest&quot;</span>, <span class="stringliteral">&quot;admin&quot;</span>);
<a name="l00168"></a>00168 
<a name="l00169"></a>00169                         <span class="comment">//Activate all Debug options</span>
<a name="l00170"></a>00170                         $this-&gt;m_obj_Connection-&gt;set_DebugLevel(cLog_Connection_Debug::c_int_LEVEL_HIDDEN);
<a name="l00171"></a>00171                         $this-&gt;m_obj_Connection-&gt;set_LogLevel(cLog_Connection::c_int_LEVEL_BASIC);
<a name="l00172"></a>00172                         <span class="comment">//                      $this-&gt;m_obj_Connection-&gt;activate_Logging();</span>
<a name="l00173"></a>00173                         <span class="comment">//                      $this-&gt;m_obj_Connection-&gt;activate_LogDebug();</span>
<a name="l00174"></a>00174                         <span class="comment">//                      $this-&gt;m_obj_Connection-&gt;activate_ScreenDebug();</span>
<a name="l00175"></a>00175 
<a name="l00176"></a>00176                         $this-&gt;m_int_COL_ID = $this-&gt;add_Column($obj_COL_ID);
<a name="l00177"></a>00177                         $this-&gt;m_int_COL_UserID = $this-&gt;add_Column($obj_COL_UserID);
<a name="l00178"></a>00178                         $this-&gt;m_int_COL_URL = $this-&gt;add_Column($obj_COL_URL);
<a name="l00179"></a>00179                         $this-&gt;m_int_COL_KeyWords = $this-&gt;add_Column($obj_COL_KeyWords);
<a name="l00180"></a>00180                         $this-&gt;m_int_COL_WholeSite = $this-&gt;add_Column($obj_COL_WholeSite);
<a name="l00181"></a>00181                         $this-&gt;m_int_COL_DateRequested = $this-&gt;add_Column($obj_COL_DateRequested);
<a name="l00182"></a>00182                         $this-&gt;m_int_COL_DateUpdated = $this-&gt;add_Column($obj_COL_DateUpdated);
<a name="l00183"></a>00183                         $this-&gt;m_int_COL_Status = $this-&gt;add_Column($obj_COL_Status);
<a name="l00184"></a>00184                         $this-&gt;m_int_COL_Description = $this-&gt;add_Column($obj_COL_Description);
<a name="l00185"></a>00185                         $this-&gt;m_int_COL_Frequency = $this-&gt;add_Column($obj_COL_Frequency);
<a name="l00186"></a>00186                         $this-&gt;m_int_COL_Sensitivity = $this-&gt;add_Column($obj_COL_Sensitivity);
<a name="l00187"></a>00187                         $this-&gt;m_int_COL_Risk = $this-&gt;add_Column($obj_COL_Risk);
<a name="l00188"></a>00188                         $this-&gt;m_int_COL_Type = $this-&gt;add_Column($obj_COL_Type);
<a name="l00189"></a>00189                         $this-&gt;m_int_COL_Reason = $this-&gt;add_Column($obj_COL_Reason);
<a name="l00190"></a>00190                         $this-&gt;m_int_COL_Comment = $this-&gt;add_Column($obj_COL_Comment);
<a name="l00191"></a>00191                         $this-&gt;m_int_COL_Discussion = $this-&gt;add_Column($obj_COL_Discussion);
<a name="l00192"></a>00192                         $this-&gt;m_int_COL_Language = $this-&gt;add_Column($obj_COL_Language);
<a name="l00193"></a>00193                         $this-&gt;m_int_COL_Classification = $this-&gt;add_Column($obj_COL_Classification);
<a name="l00194"></a>00194                         $this-&gt;m_int_COL_SCI = $this-&gt;add_Column($obj_COL_SCI);
<a name="l00195"></a>00195                         $this-&gt;m_int_COL_Distro = $this-&gt;add_Column($obj_COL_Distro);
<a name="l00196"></a>00196                         $this-&gt;m_int_COL_RequestNum = $this-&gt;add_Column($obj_COL_RequestNum);
<a name="l00197"></a>00197                 }
<a name="l00198"></a>00198 
<a name="l00202"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a42e7dcfc7851c0dedcafb63968ffbc02">00202</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a42e7dcfc7851c0dedcafb63968ffbc02" title="Saves Information to the Database.">save_Data2DB</a>()
<a name="l00203"></a>00203                 {
<a name="l00204"></a>00204                         $this-&gt;set_ColumnValue($this-&gt;m_int_COL_DateUpdated, date(<span class="stringliteral">&quot;Y/m/d H:i:s&quot;</span>));
<a name="l00205"></a>00205 
<a name="l00206"></a>00206                         <span class="keywordflow">if</span> ($this-&gt;<a class="code" href="classc_t_a_b_l_e___harvest___requests.html#acbb490790d87e7fdee9fc1d53354947b" title="Returns if the id is a valid and existing ID.">validate_ID</a>($this-&gt;get_id()))
<a name="l00207"></a>00207                         {
<a name="l00208"></a>00208                                 <span class="keywordflow">return</span> $this-&gt;<a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a8bf8fc7182a41039d94dd975a0b40229" title="This function is used to update data that is already in the database.">update_Data2DB</a>();
<a name="l00209"></a>00209                         }
<a name="l00210"></a>00210                         <span class="keywordflow">else</span>
<a name="l00211"></a>00211                         {
<a name="l00212"></a>00212                                 <span class="keywordflow">return</span> $this-&gt;<a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a2055504e90b0a396c1de85aaad0c80ab" title="This function is used to insert Data into the database.">insert_Data2DB</a>();
<a name="l00213"></a>00213                         }
<a name="l00214"></a>00214 
<a name="l00215"></a>00215                         <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00216"></a>00216                 }
<a name="l00220"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a8bf8fc7182a41039d94dd975a0b40229">00220</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a8bf8fc7182a41039d94dd975a0b40229" title="This function is used to update data that is already in the database.">update_Data2DB</a>()
<a name="l00221"></a>00221                 {
<a name="l00222"></a>00222                         $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, $this-&gt;get_id());
<a name="l00223"></a>00223                         <span class="keywordflow">if</span> ($this-&gt;do_Search() &gt; 0)
<a name="l00224"></a>00224                         {
<a name="l00225"></a>00225                                 $obj_RS = $this-&gt;get_ResultSet();
<a name="l00226"></a>00226 
<a name="l00227"></a>00227                                 $this-&gt;set_date_requested($obj_RS[0][$this-&gt;get_Column_Name($this-&gt;m_int_COL_DateRequested)]);
<a name="l00228"></a>00228                         }
<a name="l00229"></a>00229 
<a name="l00230"></a>00230                         $this-&gt;clear_Update();
<a name="l00231"></a>00231                         $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, $this-&gt;get_id());
<a name="l00232"></a>00232                         $this-&gt;set_date_updated(date_format(<span class="keyword">new</span> DateTime(), <span class="stringliteral">&quot;Y-m-d H:i:s&quot;</span>));
<a name="l00233"></a>00233 
<a name="l00234"></a>00234                         <span class="keywordflow">return</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a8bf8fc7182a41039d94dd975a0b40229" title="This function is used to update data that is already in the database.">parent::update_Data2DB</a>();
<a name="l00235"></a>00235                 }
<a name="l00239"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a2055504e90b0a396c1de85aaad0c80ab">00239</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a2055504e90b0a396c1de85aaad0c80ab" title="This function is used to insert Data into the database.">insert_Data2DB</a>()
<a name="l00240"></a>00240                 {
<a name="l00241"></a>00241                         $this-&gt;add_Sort($this-&gt;m_int_COL_RequestNum, cConnection::c_str_SORT_DESC);
<a name="l00242"></a>00242                         <span class="keywordflow">if</span> ($this-&gt;do_Search() &gt; 0)
<a name="l00243"></a>00243                         {
<a name="l00244"></a>00244                                 $obj_RS = $this-&gt;get_ResultSet();
<a name="l00245"></a>00245                                 $this-&gt;set_requestNum(($obj_RS[0][$this-&gt;get_Column_Name($this-&gt;m_int_COL_RequestNum)]) + 1);
<a name="l00246"></a>00246                         }
<a name="l00247"></a>00247                         <span class="keywordflow">else</span>
<a name="l00248"></a>00248                         {
<a name="l00249"></a>00249                                 $this-&gt;set_requestNum(0);
<a name="l00250"></a>00250                         }
<a name="l00251"></a>00251                         $this-&gt;set_id($this-&gt;create_GUID());
<a name="l00252"></a>00252                         $this-&gt;set_date_requested(date_format(<span class="keyword">new</span> DateTime(), <span class="stringliteral">&quot;Y-m-d H:i:s&quot;</span>));
<a name="l00253"></a>00253                         $this-&gt;set_status(0);
<a name="l00254"></a>00254 
<a name="l00255"></a>00255                         <span class="keywordflow">return</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a2055504e90b0a396c1de85aaad0c80ab" title="This function is used to insert Data into the database.">parent::insert_Data2DB</a>();
<a name="l00256"></a>00256                 }
<a name="l00257"></a>00257 
<a name="l00263"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#acbb490790d87e7fdee9fc1d53354947b">00263</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#acbb490790d87e7fdee9fc1d53354947b" title="Returns if the id is a valid and existing ID.">validate_ID</a>(<a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>)
<a name="l00264"></a>00264                 {
<a name="l00265"></a>00265                         <span class="comment">// ensure that there is an ID passed and that it is a valid GUID</span>
<a name="l00266"></a>00266                         <span class="keywordflow">if</span> (!empty(<a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>) &amp;&amp; preg_match(self::c_REG_GUID_VALID, <a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>))
<a name="l00267"></a>00267                         {
<a name="l00268"></a>00268                                 $this-&gt;clear_Query();
<a name="l00269"></a>00269                                 $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, <a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>);
<a name="l00270"></a>00270                                 <span class="keywordflow">if</span> ($this-&gt;do_Search() &gt; 0)
<a name="l00271"></a>00271                                 {
<a name="l00272"></a>00272                                         <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00273"></a>00273                                 }
<a name="l00274"></a>00274                         }
<a name="l00275"></a>00275                         <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00276"></a>00276                 }
<a name="l00277"></a>00277 
<a name="l00283"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a7f7d36d28f818d0d64ae30da6f170a0a">00283</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#a7f7d36d28f818d0d64ae30da6f170a0a" title="Loads information into object from Database based on ID passed.">load_DataFromID</a>(<a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>)
<a name="l00284"></a>00284                 {
<a name="l00285"></a>00285                         $this-&gt;clear();
<a name="l00286"></a>00286 
<a name="l00287"></a>00287                         <span class="keywordflow">if</span> (!empty(<a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>) &amp;&amp; preg_match(self::c_REG_GUID_VALID, <a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>))
<a name="l00288"></a>00288                         {
<a name="l00289"></a>00289                                 $this-&gt;clear_Query();
<a name="l00290"></a>00290                                 $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, <a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>);
<a name="l00291"></a>00291                                 <span class="keywordflow">if</span> ($this-&gt;do_Search() &gt; 0)
<a name="l00292"></a>00292                                 {
<a name="l00293"></a>00293                                         $obj_RS = $this-&gt;get_ResultSet();
<a name="l00294"></a>00294                                         <span class="keywordflow">if</span> ($obj_RS[0])
<a name="l00295"></a>00295                                         {
<a name="l00296"></a>00296                                                 $this-&gt;load_DataFromArray($obj_RS[0]);
<a name="l00297"></a>00297                                                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00298"></a>00298                                         }
<a name="l00299"></a>00299                                 }
<a name="l00300"></a>00300                         }
<a name="l00301"></a>00301                         <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00302"></a>00302                 }
<a name="l00308"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#afa5d2965543d553ce73d7e845737d7f2">00308</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#afa5d2965543d553ce73d7e845737d7f2" title="Check the validity of the data about to be saved.">validate_New</a>()
<a name="l00309"></a>00309                 {
<a name="l00310"></a>00310                         <span class="keywordflow">if</span> (!$this-&gt;get_url())
<a name="l00311"></a>00311                         {
<a name="l00312"></a>00312                                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00313"></a>00313                         }
<a name="l00314"></a>00314                         <span class="keywordflow">if</span> (!$this-&gt;get_description())
<a name="l00315"></a>00315                         {
<a name="l00316"></a>00316                                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00317"></a>00317                         }
<a name="l00318"></a>00318                         <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00319"></a>00319                 }
<a name="l00320"></a>00320 
<a name="l00326"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aaa644385d5cf5a91cf83f059805e3f6f">00326</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aaa644385d5cf5a91cf83f059805e3f6f" title="Convert a Status Value into the Status Label.">convert_StatusValue2Label</a>($str_Value)
<a name="l00327"></a>00327                 {
<a name="l00328"></a>00328                         $obj_Table_DropDownOptions = <span class="keyword">new</span> <a class="code" href="classc_t_a_b_l_e___drop___down___options.html" title="Includes the base class for Tables (uses base path from the cinfo file.">cTABLE_Drop_Down_Options</a>();
<a name="l00329"></a>00329                         <span class="keywordflow">return</span> $obj_Table_DropDownOptions-&gt;convert_Value2Label(<a class="code" href="classc_t_a_b_l_e___drop___down.html#a89d5250c074d26a46bfc10ca45e6a88e">cTABLE_Drop_Down::C_STR_DROPDOWN_HR_STATUS</a>, $str_Value);
<a name="l00330"></a>00330                 }
<a name="l00331"></a>00331 
<a name="l00336"></a><a class="code" href="classc_t_a_b_l_e___harvest___requests.html#acadc655fe0cf4d0618d8af87d73fdce4">00336</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___harvest___requests.html#acadc655fe0cf4d0618d8af87d73fdce4" title="Gets the Status of the current Request in Text Form.">get_StatusTxt</a>()
<a name="l00337"></a>00337                 {
<a name="l00338"></a>00338                         <span class="keywordflow">return</span> $this-&gt;<a class="code" href="classc_t_a_b_l_e___harvest___requests.html#aaa644385d5cf5a91cf83f059805e3f6f" title="Convert a Status Value into the Status Label.">convert_StatusValue2Label</a>($this-&gt;get_status());
<a name="l00339"></a>00339                 }
<a name="l00340"></a>00340         }
<a name="l00341"></a>00341 ?&gt;
</pre></div></div>
</div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><a class="el" href="c_t_a_b_l_e___harvest___requests_8php.html">cTABLE_Harvest_Requests.php</a>      </li>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>


    <li class="footer">Generated on Mon Jan 23 2012 13:34:20 for AmpleHarvest by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.5.1 </li>
   </ul>
 </div>


</body>
</html>
